IF NOT EXISTS(SELECT name FROM sysobjects  WHERE name = 'SubsidyDetails')
BEGIN 

CREATE TABLE [dbo].[SubsidyDetails](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[SubsidyHeaderId] [UNIQUEIDENTIFIER] NOT NULL,
	[CommodityCode] VARCHAR(15),
	[GoodsCode] VARCHAR(15),
	[Quantity] MONEY,
	[UnitCode] VARCHAR(3),
	[Amount] MONEY,
	[AssigedCredit] MONEY,
 CONSTRAINT [PK_SubsidyDetails] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)  ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[SubsidyDetails] ADD  DEFAULT (NEWID()) FOR [Id]
END